SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348503 LIMIT 1 [ RunTime:0.003169s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348503 [ RunTime:0.009852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311822,914988,565168,976407,701602,385891,197687,185883,115848,63547,658301,880550,275571,990473,500672,93881,153463,74451,270976,440976,86037,436564,652023,97950,265294,873233,39750,553192,56478,186442,156094,659286,438898,745590,160713,817502,544804,731476,172954,769962,842254,545675,472140,137910,621733,676390,177495,980956,750366,269169,236441,263339,560787,352299,454795,882481,167769,749139,50049,616898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001439s ]