SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261224 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261224 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517570,978574,274792,218243,375698,141918,120257,331473,463546,888872,1026221,851609,939693,555381,15072,1077,194144,716311,99429,513406,386947,117532,358920,144474,277762,49844,72371,480264,708577,343494,960130,24473,208462,357641,753775,409963,278934,448563,774443,632112,1028160,163101,702691,1028516,861010,939004,358301,881227,927064,557887,301547,106195,397605,713666,821623,686699,926109,161742,892753,802424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]