SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395451 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395451 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273135,376723,269258,376960,65045,603036,280720,14359,988083,905800,641103,819001,858374,458205,865370,955374,401875,613463,669667,1012697,695084,870097,1044583,759289,599256,474643,509355,377120,602723,595683,242955,73462,432093,816268,192154,915795,364861,454879,403740,390778,665817,642874,59965,909480,32696,793638,92876,332582,695952,761785,906521,875794,913766,996682,635682,857042,723744,412143,130090,34532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001303s ]