SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291536 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291536 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247879,180599,141603,499450,440021,119167,239530,599235,418862,429958,513719,109012,505380,115339,873162,255280,106439,706802,445937,815488,1001312,805832,531997,246477,975240,253887,781634,168492,537517,501950,700776,209877,251169,835020,801917,31358,752663,195572,968903,551052,301341,352034,128783,863902,53561,242118,647404,36185,839656,706338,202694,1032306,1041642,768828,1006303,27174,814827,772374,432427,93346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]