SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414394 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414394 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57933,737685,1034283,941824,732804,782985,971617,967973,743646,457524,59440,332182,402621,957511,318999,607191,667144,469835,99457,475880,917820,243886,967309,897055,253169,573621,597385,125586,924738,645019,901246,643542,525276,248138,241113,808759,732248,906311,806771,414404,910513,1013466,225542,72479,935016,622485,64564,1003097,487469,427603,1018765,405649,616937,835304,715597,119566,888928,1001617,916335,150864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]