SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464251 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464251 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63280,624490,168574,337248,30668,992937,355373,701796,848413,676522,80218,366538,122028,309959,574698,964085,725322,645655,237536,207256,1041139,83881,625081,466466,945624,972139,905039,498422,699608,746276,686025,193213,455349,676699,823350,503123,1009366,204827,269186,984897,39743,947460,683753,842719,48365,840578,894246,455918,154589,521740,86977,908476,591417,426953,823024,223813,358310,155868,353863,292514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]