SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567041 LIMIT 1 [ RunTime:0.000774s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567041 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502651,614532,892984,1000410,343374,756848,558637,519511,228014,705948,854718,1039452,91023,366858,353161,219285,111386,38212,535707,449768,325073,712243,110034,462842,402167,701727,31718,277545,847166,951125,851238,342510,934998,429648,427974,468762,325814,141149,508225,287960,417126,347234,509494,103617,576242,453615,190306,436973,147186,879349,562120,485014,704569,770140,140641,892976,602184,317846,983620,537252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001093s ]