SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014197 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014197 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407969,152976,332262,457689,154084,692255,221288,632218,337642,600138,690283,851692,1020819,731714,112937,781586,858780,742486,603762,782683,673259,3927,692137,232038,930683,469451,705026,226054,819568,449191,1013111,637364,128983,439746,963465,954961,741917,594739,68652,128426,566430,230870,24167,320746,476714,1019917,73123,322955,948169,945811,385722,389005,800388,252113,335202,869603,703999,476835,283462,222636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]