SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520991 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520991 [ RunTime:0.002817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691088,388074,938923,230088,898621,327202,929140,79190,1023760,914130,495915,862643,1044098,166933,85310,890118,521888,810033,158216,806118,223604,828812,459110,479595,111589,109071,563835,800040,926361,263677,376658,745592,568102,489516,448539,696395,529913,115307,190565,299347,484405,81876,336182,838037,579543,653903,291978,212962,244865,886395,984670,201020,818316,664026,509047,871885,421684,68946,444954,392554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]