SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415629 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415629 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873212,480474,409371,202210,899979,363814,13059,113524,298711,1018671,602387,994000,98744,847711,578032,322221,39285,6731,116905,1029475,452403,322792,557026,862294,946808,231191,215056,63428,929714,434213,374064,256054,830653,484560,368029,182100,522342,149685,49690,335615,977558,852325,276731,213452,389471,677438,304685,10522,156537,46980,46592,411278,912199,167506,979875,74160,873431,152129,449326,437739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]