SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515224 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515224 [ RunTime:0.002837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50479,908842,18609,373549,747385,22317,665255,466138,650787,965253,734762,382917,153213,690662,299228,1032886,645267,431060,1004775,21156,530213,1016138,862674,721797,222751,332402,944250,129413,491951,563787,216924,669423,478160,941141,322637,931881,147527,1013320,450231,92259,187041,494875,848053,905937,298202,871603,1017017,216389,117526,204126,679839,238056,621537,73626,125198,400364,461570,60478,149159,138933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]