SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508399 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508399 [ RunTime:0.003030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763897,328983,493611,361483,209871,119403,22136,964926,343014,322965,29260,347693,732725,303696,315084,819092,296015,9809,989358,335087,200587,230435,514542,745335,837987,128095,1013738,601418,1033407,1010150,951843,627909,817072,83346,434331,385033,858531,53597,56865,347297,734457,894687,1025753,800566,587606,311605,249870,408028,652286,442404,296284,978899,1033313,960771,345370,285193,288336,915885,1029965,164392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003454s ]