SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580484 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580484 [ RunTime:0.004039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557318,470881,387849,888228,576786,663429,649667,694213,960303,582375,844147,426667,785570,662860,173234,616355,385455,186157,378091,547333,148860,854694,715680,1035286,1019510,682031,632685,370538,252393,726499,270605,323427,446622,588677,594683,704972,840759,342308,1004706,676407,794143,512692,725639,295375,58024,336697,253361,143717,1017128,977261,790928,764621,225825,795936,530126,200788,515211,553677,983370,238910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001420s ]