SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529222 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529222 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670218,642812,791840,1023837,875043,301319,834945,849160,353360,687028,893909,45448,575127,698702,383903,719007,399709,738658,781337,964828,94374,288242,40006,779534,497846,768462,245793,372612,815735,133095,193558,164569,96795,788859,425918,670058,50291,748209,886205,812066,349809,212629,949761,404718,778687,781718,826743,90153,858857,831512,124679,636611,764424,374884,795061,360557,358859,104000,286327,366819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]