SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319406 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319406 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283173,534957,14891,817053,1042848,438781,133824,401618,122413,354211,293883,777187,893164,521992,413586,174295,794877,10258,1009237,329323,438898,617120,1011069,945494,947228,440479,32955,33123,399167,997808,53521,725724,397956,177040,852169,520096,204407,383596,1015350,472730,187976,592210,139732,541668,977172,831245,290394,1041818,768354,684635,2464,536122,779759,268531,105234,768075,961288,837453,185015,84330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]