SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200825 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200825 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823576,986269,366679,369269,124348,1026916,253503,291704,123620,552805,340133,298639,15505,895314,1044307,53994,375132,556253,723591,572234,721901,438959,289811,207338,386306,391429,54815,267382,198153,71258,674834,509105,626221,311123,32177,432028,462014,894916,646276,609523,64575,827775,801022,285774,277920,167947,641818,893889,664587,1046521,628863,287099,765161,134587,238779,624666,143840,33113,843269,122549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]