SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597816 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597816 [ RunTime:0.003868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198888,724015,292683,476306,895023,223722,402140,854158,589384,795790,109461,19050,163504,377795,124835,1032592,18016,122050,999606,617898,379268,543842,918696,635594,53160,618032,270760,752095,735728,709875,402631,389063,68494,395455,111971,158965,173607,773358,886337,525685,60729,233029,803666,746582,837945,587028,1039167,204673,384746,733008,81975,598684,277489,624885,863361,216530,111939,458973,824284,998135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000824s ]