SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510473 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510473 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583553,471166,283494,248454,842838,885432,501475,475331,1003070,272475,261916,155859,909888,690119,243857,1015504,289316,761628,489890,260888,507950,93121,811350,232560,331156,143019,30384,982793,384108,702681,534480,47685,457568,912715,231028,316414,254040,524066,992080,359311,650942,1011848,812763,202928,20571,619236,288159,278246,313081,526703,239310,728199,88771,769169,245837,534647,131225,605985,265016,762914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]