SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504681 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504681 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148503,99642,748599,605370,779051,462425,59299,35643,615412,348948,732572,908475,794566,700731,717525,639845,333063,758501,996043,597179,782749,635584,102241,343913,644221,511094,744128,659690,1007322,421071,781609,104333,412655,53348,727510,868097,635743,649927,1038345,900160,943286,289847,635328,278538,75250,162048,404054,210841,925389,733210,433083,175853,406020,128701,908999,865985,280504,107482,806166,511660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]