SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 870318 LIMIT 1 [ RunTime:0.001154s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 870318 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506797,844087,502428,367221,486824,442053,268043,107197,241697,113821,574231,225861,500885,204828,725605,23325,980005,798392,840482,443736,1030823,946195,916157,996334,479155,6447,432271,638358,706369,603152,702935,350573,674459,1020029,782215,776914,112436,800140,252832,745578,902636,796127,150464,675521,771411,386299,929790,833647,806598,968760,696671,943643,255451,3620,55735,380730,1042506,801419,760575,416357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 870318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 870318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]