SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105094 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105094 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676446,425448,951829,874906,910294,811948,953614,155208,735172,55023,499087,927920,712328,241900,579627,488309,151091,662753,385096,685867,145639,75896,475537,78808,504902,803169,519387,830244,962710,106742,650325,720128,115358,978889,975973,369462,232799,577057,607646,943568,297066,236805,440273,750350,30584,53324,451226,299778,581910,93258,924884,195370,612204,445710,952025,315016,407395,991633,273401,318484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]