SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417918 LIMIT 1 [ RunTime:0.001159s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417918 [ RunTime:0.003119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458828,385608,656572,269540,229527,567804,684395,927155,22687,530363,420043,348247,406076,339973,771752,456893,240595,457210,1016564,354872,850983,639630,592300,616805,845409,748100,526301,727443,373981,125184,988347,520687,153458,1025894,523333,1013808,526246,108654,443539,172138,102719,434518,723537,69517,781637,28908,220955,811035,359227,80797,909992,668490,224201,776985,855592,454334,997124,889988,780898,555346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]