SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534071 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534071 [ RunTime:0.002661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845730,248587,222233,831729,563482,413150,901974,1042672,194804,654294,972558,440612,44914,170354,1039037,84589,177838,912147,145081,466985,485016,889327,519569,596189,668974,207976,815255,498061,128593,620440,49278,510877,556176,116317,104977,333676,793105,246271,623049,586437,138145,685634,1017248,330452,669461,781121,785269,296238,110991,1005823,380927,194692,289491,259172,561807,620270,184199,795333,702058,694378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]