SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331191 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331191 [ RunTime:0.003773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922263,722512,306684,371279,898037,1004699,247073,553745,103070,979729,394353,92466,282887,910168,996702,396317,419879,228971,447898,352863,418362,947062,282802,42390,538814,874553,723635,329509,1045331,509989,737789,629861,67749,1009104,560387,645991,829294,276858,113953,925623,255838,422158,97496,442570,955391,450604,118365,844,46109,434592,829655,346217,76982,526063,111195,665906,792938,1015026,419156,25783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]