SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407101 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407101 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774426,156434,1040395,72610,455848,80072,800204,390345,820761,997317,134386,449954,731992,445048,110717,628079,333958,635311,785850,723089,93289,574579,740505,771267,667987,85856,356218,569847,1028999,473843,783369,261368,753487,434639,970829,695638,733081,74866,40959,480959,341892,88445,178789,512983,635210,222224,686090,975718,354366,885309,735088,100300,896194,239970,526118,382763,443918,363879,386819,886196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]