SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397834 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397834 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382632,528446,637581,881976,139787,12011,779679,926524,206062,308088,209011,234553,1026036,440386,133220,448949,885356,951475,311160,260458,987771,177908,781856,387268,66385,217555,561287,376442,896782,374192,429997,1030033,693436,208563,466468,574575,566618,847809,247939,506411,149882,323767,894497,100357,775267,593702,792017,619796,745729,525909,201023,888307,175302,299,589344,397389,24385,416636,86186,959999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]