SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105964 LIMIT 1 [ RunTime:0.000636s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105964 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457743,361567,979924,375186,655129,417902,939794,712726,258520,487969,948511,230554,183527,971087,624036,200009,756317,976426,926029,724489,496655,816217,27502,25840,901314,516806,965420,1028640,640838,252185,994284,854578,809907,823402,220673,674093,623842,301169,780505,895544,638072,911634,657859,989768,955216,91849,200290,757145,147681,598134,10993,490116,885305,121670,329073,263765,493269,417645,864668,702630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]