SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037076 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037076 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899133,449808,466052,1016292,501517,1008457,256890,506572,32002,100011,705140,1022512,1015665,950664,827145,298487,309098,240713,951861,815337,617810,805622,913557,636568,472569,414684,214771,575859,220448,667547,442339,546462,576230,867886,936965,395417,909465,1029945,490387,323325,784995,146449,809564,191841,938511,602103,510260,31473,710703,731675,149696,52205,514930,498252,103224,248740,415617,651452,316642,45593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]