SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329144 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329144 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650419,149088,17013,915442,379525,952226,365244,329469,103836,392578,25824,655162,1007167,195727,434661,414251,14718,388539,630791,647558,100164,853245,553796,248197,882384,325773,291450,877838,924110,676573,369398,379979,902306,349482,579988,500473,881127,800764,781259,748479,967370,110815,61851,129041,174644,677503,543042,413776,244936,796091,318561,746084,518709,676839,749006,464634,436185,464064,771157,677997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]