SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19803 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19803 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576977,461663,863606,665661,899223,366372,999546,41364,888740,626787,487642,190888,676438,744530,325808,535758,327404,916509,361538,336341,103462,11696,629918,509700,979311,818556,971615,994791,350740,316130,296902,125197,709756,30198,502513,728937,401175,224533,874935,328409,860754,960376,398446,281079,342262,538225,310083,932793,563753,1013500,596953,1021617,388190,645010,304266,174706,730658,580292,168959,896110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]