SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537043 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537043 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020189,604018,755274,624033,957080,389107,284526,27645,807568,522552,206898,832657,915716,356734,855563,976445,515324,998492,590787,219435,885303,458938,748887,428099,46279,156957,994128,481628,959492,188658,576234,316691,623966,970043,290153,129144,188355,840681,842159,630568,920451,50718,874225,476692,889265,779456,878550,763036,742500,450041,783326,194227,402462,547029,228948,72503,792199,950396,783786,516199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]