SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510654 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510654 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589844,459556,464991,1007969,546881,236316,160638,14731,101804,194406,269941,755347,667897,292363,146553,1021365,386785,207081,240108,700616,377043,83066,971129,96721,752243,596276,669116,985164,402857,399698,873977,929822,888630,974272,354768,899521,325660,789813,103947,891492,628620,453933,426685,431551,747781,582781,988557,1022605,971326,122002,527044,539658,1030749,282853,153502,625423,149183,934320,524947,241482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]