SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504853 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504853 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107287,978162,181887,641646,793774,85600,447851,613047,951363,266161,26988,1045671,511557,409033,947014,95127,747148,214814,27697,155578,388240,889340,596857,550267,389942,735833,298714,530316,465658,413479,99442,900874,505706,878767,287061,332166,749986,313438,763744,358705,1017023,616159,410417,768408,75756,449786,358164,360166,1025654,606874,68171,383441,217890,46430,506509,680827,910124,65980,381030,627838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]