SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008371 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008371 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369884,448636,548455,689831,357749,1022490,851677,379929,708152,285846,688100,150650,111987,390042,67526,440304,55835,233818,569658,535625,144961,529177,207458,204664,364038,808039,611803,335310,94014,614730,589862,790344,915320,282672,205652,907693,341936,427383,952509,233499,374697,155614,896101,776717,775646,285084,710845,156963,61648,48903,767042,580117,669268,633404,895539,45904,942150,804474,644841,822963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]