SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024047 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024047 [ RunTime:0.003980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450539,981865,689806,730896,832494,726538,778857,423230,50774,996277,978652,8370,319847,407703,641207,218146,845571,216170,975090,967921,364426,792616,925306,297493,327874,173728,312109,607166,837318,768647,305238,1008552,100787,1007234,110282,696876,151070,58472,63997,268682,302048,187961,129747,716311,998814,277068,515680,849499,1043975,496051,975627,932372,258072,270516,172705,893650,356776,701447,630174,761732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]