SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004628 LIMIT 1 [ RunTime:0.001105s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004628 [ RunTime:0.005847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571063,421498,767899,895825,796438,1016972,411920,722455,335553,80611,371214,303688,139708,806742,843581,51794,528760,256023,1001876,87004,732546,440050,869091,745048,582884,875487,59546,242380,356976,861203,496752,323427,561587,177904,749946,502568,622136,216243,1014716,522842,291317,346673,319100,526225,106204,580314,474644,794883,628766,723586,244769,2626,698971,748805,223941,629815,926304,258461,787678,164223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]