SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491001 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491001 [ RunTime:0.003502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927694,1012041,887415,837814,937429,847149,350199,663915,1014890,877334,639539,742805,77613,556444,413648,426459,866195,592154,731270,314067,768955,1036254,170886,1045096,400122,721050,889677,382538,348698,531410,700532,413586,606608,403845,834918,80660,792576,1025335,58774,680683,1045539,762801,882950,204519,766983,52112,139410,671671,179687,567350,416057,747335,415158,802217,550552,725383,70483,59994,977648,114017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]