SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 844571 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 844571 [ RunTime:0.002637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589820,247562,732938,908068,587285,56252,863403,640271,726176,166752,252897,901163,783426,28262,366907,664369,132491,1021256,94507,700249,971479,940218,607521,1015924,1001731,353735,513376,715457,473841,375272,570047,420094,380764,369283,230456,864382,858284,617441,908529,560861,128872,69489,910744,227858,697022,911630,707842,535467,468788,537082,881441,761874,440452,345826,464660,371748,694891,452620,427469,803707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 844571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 844571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]