SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044144 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044144 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042791,879744,394320,375342,627065,960850,205065,651665,545602,361105,1046215,794055,1005931,228529,514404,235797,383253,23752,28335,930675,314961,295066,209897,177932,536750,770202,1030004,85907,55117,685181,649783,792756,48426,468842,174122,73,382906,865726,756692,984352,455063,945128,428412,444993,16814,834071,995700,100621,510018,102150,493171,1038814,820053,190267,167638,885764,68159,217847,508239,225691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]