SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401276 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401276 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658066,155529,786799,692143,97623,783144,938905,917366,289968,373351,803530,75564,872145,309814,334417,766108,437264,684666,174064,908813,586118,495629,758351,247033,544530,984098,275331,29872,765290,509797,717885,479758,202126,808894,884145,282226,808182,491927,143355,803029,795361,311292,633863,835468,1019498,434201,325566,469910,659757,558028,730797,159040,230930,180276,269566,801952,454350,754580,94400,331895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]