SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267250 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267250 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802512,82426,507126,292027,990106,261464,618903,602515,998986,303163,124320,589404,13152,106573,615383,205273,838025,258208,525293,403547,298024,417565,437720,853449,787787,765837,456316,652767,408238,489342,133316,350441,62133,469972,638816,365102,936969,288091,1024160,1035108,995793,245057,133125,269113,371960,137409,400170,805791,127055,140094,358788,30796,165528,332698,474222,1018768,31016,428455,241896,684392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]