SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409631 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409631 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599400,798986,64195,652826,72641,720504,812954,843718,454931,468454,768934,172523,303511,113064,549682,667854,178251,715790,131864,436753,707828,320930,491072,671970,375016,155865,23362,840162,813291,495546,452612,516102,738405,357676,805565,127025,418390,439619,365839,315459,760841,127791,693509,10198,455658,314694,1046859,395592,366149,444569,261752,933623,775147,449733,430068,428642,209755,927304,794324,485299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000371s ]