SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809854 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809854 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852780,192947,237542,907111,838671,967040,1036347,323778,141877,439657,313755,520181,868355,896224,485279,344028,115411,174296,830344,925463,999890,5314,441460,246245,873996,807050,591054,426333,759763,880319,916666,248740,52395,529554,900195,846671,936241,695057,763354,742083,217965,728141,689653,162533,106742,687336,705941,120460,753311,445535,420689,421361,811547,731524,298035,304175,719098,913862,808131,511083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]