SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522006 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522006 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121934,924736,112040,703716,1015895,544607,133561,661222,334265,311502,51394,703086,573607,915800,884278,326351,978641,225209,751913,475634,641923,934386,29657,429752,243506,629724,369868,56721,1048183,461509,109402,617888,592260,933897,113621,684949,785407,781556,3145,551241,501385,388275,345023,600273,110314,977360,329085,295900,3968,928643,42326,582331,720343,958818,254900,231937,88846,912573,131491,752072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]