SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304100 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304100 [ RunTime:0.002243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483722,1039732,14406,688747,394669,205789,839478,48038,960534,657008,930061,397546,23037,36579,140392,734304,998237,503172,410165,955414,1011254,872483,492387,152472,79931,1040965,707934,700582,103139,391855,1032803,6811,510701,63984,18815,280670,691440,726198,411305,664143,828953,246249,460075,986725,235203,197087,913690,914634,814071,692836,104043,586238,663943,736151,484954,943161,796926,128346,502091,724838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]