SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393905 LIMIT 1 [ RunTime:0.002362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393905 [ RunTime:0.002373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253882,592488,691582,1042793,725503,782126,584873,38609,555873,324861,827248,464006,946193,608263,502067,230207,118441,775885,821663,104147,756152,915879,777990,1048868,457330,893640,753297,495370,901963,46414,516394,528863,975402,804367,873112,9478,625739,115174,662137,242439,949350,101830,843870,185281,929419,905445,806984,403580,861563,622392,692087,991629,530850,67323,430726,668049,550285,25650,614875,383239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]