SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533610 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533610 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707860,759778,308468,550829,154381,629120,358090,861253,273961,751095,904181,686550,487364,763301,652582,629351,920510,795680,684056,147562,540672,729000,93430,825389,348903,112535,110332,767456,693975,763259,367636,696812,581032,665541,310971,244562,609826,665103,839272,567676,1026838,115091,85233,703354,407667,610435,624364,700503,351210,357256,935006,746299,434047,956147,771491,601456,724467,148321,420485,323193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]