SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038009 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038009 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848004,60954,329739,725466,960756,986566,424701,529534,800681,760460,1030208,394923,887970,536448,408145,853356,686761,445920,489770,62011,200876,608246,25807,207418,344038,651945,947969,804747,823061,578683,113066,1014767,999537,785380,896958,184206,56598,882662,66885,287421,905327,29691,35782,943114,324480,1041782,319098,172403,251506,329853,780101,563083,833892,141484,22634,72660,185694,138428,984171,203037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]