SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 819508 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 819508 [ RunTime:0.002820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933048,1013510,413959,640249,695124,642853,456965,338173,507148,318202,752442,443868,736423,786832,979953,1031947,422255,427122,9726,252950,302521,93768,385017,1037202,510338,494520,1008801,377375,863713,881338,266072,152756,578989,473489,356300,248533,1013241,524748,979919,748415,430973,572591,529834,307058,239499,260262,656333,69983,239078,144518,154190,244503,475053,670932,181735,880395,248067,279389,901420,341587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 819508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 819508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001873s ]