SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548316 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548316 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702188,914269,533441,852613,275266,510567,250986,266687,538357,370551,834292,743936,809113,851460,442030,373405,809494,734440,552802,343755,971768,488683,122667,661269,128312,248609,551606,608251,912782,706107,547111,439510,696188,387808,483109,850443,862099,237205,237184,483753,745767,282265,544574,342019,27859,621850,1043240,54135,264954,673251,710348,235532,509471,1045680,901943,522772,931868,1037547,432444,496314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]