SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53854 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53854 [ RunTime:0.002910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675768,161875,776576,557160,559897,653487,611916,972006,349064,211266,607379,497826,912833,1001859,749375,65621,616781,601551,444848,311606,639399,42434,606406,817371,939756,198134,67829,885807,692414,437903,931693,544655,1020720,502608,378646,288026,1035583,295109,703606,117520,5149,710322,409971,62747,619365,139368,619559,816181,959955,732647,223500,709323,997882,821001,721893,845557,340578,151681,49076,103324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]