SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358183 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358183 [ RunTime:0.003383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536334,487200,228267,90191,319172,869919,535801,391807,922638,753081,539053,168356,136480,4353,815097,692673,337776,242763,905673,91314,839274,12567,996028,753187,955460,428480,249779,715760,124493,982989,321573,798065,465300,48468,758184,312155,493952,646202,89687,444719,947987,88879,907094,276833,900470,583622,280279,108876,552266,382576,422602,864094,47421,59809,996340,238424,781368,363150,570380,612584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]