SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368103 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368103 [ RunTime:0.004631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201492,744739,333755,953953,362056,303709,904678,205148,523481,5725,742954,491113,465627,157687,840880,1022769,771624,230570,449916,867514,428126,820498,1001390,733159,704247,17883,30467,776082,52325,919341,951,897750,825756,91666,449587,392342,676993,784936,112959,1048880,529794,830954,262875,142207,106919,943013,519185,667400,875776,1031716,472293,597029,366088,381639,678898,964406,102443,25076,952816,875730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001484s ]