SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412831 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412831 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107516,57507,840521,502068,541631,59400,1034828,1020449,272047,640750,1013244,404962,1645,951202,730907,141419,440966,704790,669036,830324,778886,998485,668314,202538,95836,39901,164688,70354,750636,984864,218333,519204,1028982,540839,257818,987446,144317,1011300,313224,275228,646008,351191,854980,575340,290025,329525,443905,828564,560935,745255,564786,852462,978323,156693,433315,872685,299476,485984,1024713,836849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000945s ]