SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341284 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341284 [ RunTime:0.002681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608163,513656,800672,459146,165482,366788,372144,112315,879223,899962,703563,628702,982844,609601,547086,4664,91848,441089,421135,732494,1017781,570004,9362,999152,331112,290743,202655,847387,305919,893863,1011438,355514,63678,423522,51904,855750,204040,924679,804812,558335,748908,484350,416650,834371,404066,215603,196340,967514,555020,948780,835223,549754,230171,340638,937894,624736,937632,271079,124374,1040557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]