SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490263 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490263 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825171,101637,725112,891888,1025164,261351,83305,199022,620114,536371,374765,217577,513430,618841,542019,969203,1025988,321282,679454,946782,760772,100129,309574,16095,568869,44535,677616,928682,588560,79740,127803,906520,666618,656976,519024,682017,963491,208261,247803,533415,687429,320964,633039,887640,544517,590469,333949,457151,985674,917089,515259,324620,678886,638184,144438,868984,980909,34167,277833,884306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]