SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506618 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506618 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140998,88275,1041608,591907,287600,526382,481458,732841,199977,644932,336568,966062,547416,998353,452891,901670,399912,951375,516625,842110,490271,246448,370917,55583,680884,48723,584672,981212,110220,924175,221614,445206,694308,394673,203653,1046861,982134,216632,405447,398285,32493,642090,218519,403662,675372,749095,71042,602369,349171,27444,926807,508653,658500,1045049,1015674,302394,305100,53341,237361,991732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000749s ]