SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544832 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544832 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715032,149187,429159,638387,1028622,631240,594317,369098,491265,241874,72315,902545,478826,84418,974206,595186,692546,441103,367149,167720,89766,1034471,139865,213509,388,682877,954315,387905,138188,655096,608132,223942,55282,407127,13235,129642,198103,1046060,224265,900195,448828,905199,865610,786006,531779,918875,653778,17228,772095,573709,618838,971070,731681,276947,947139,20502,561646,111271,382055,638939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]