SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201050 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201050 [ RunTime:0.006058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483988,377758,490450,936900,648638,477190,663785,790389,204445,115772,589549,48309,206350,15417,1013841,558748,903653,84879,579537,317012,1031037,9112,882596,816636,266559,190740,443309,17504,906795,333775,825679,980786,807481,761646,597865,811199,538122,262369,499705,60028,908021,2032,781242,174607,545171,387924,955383,728376,271707,554211,866303,334747,845823,120473,958695,759877,935893,639203,754110,214817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]