SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404699 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404699 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400811,943112,653163,493877,154419,121893,220597,742736,670516,50121,809237,406702,948358,8939,188226,20159,560625,432683,1028296,305974,718068,1022537,76688,4316,115084,931931,748871,126120,268622,434633,280975,494052,57654,556636,845357,534768,644913,391747,990638,465398,691295,302699,745256,947779,141714,797098,280683,823402,807567,321660,1035817,300625,427696,1013909,209084,643230,867591,677272,871124,613611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]