SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436042 LIMIT 1 [ RunTime:0.001147s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436042 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043888,965451,115081,506446,860498,889075,249706,80839,701744,628721,107502,977425,650465,606892,514776,49808,675204,308000,986045,879433,242312,644791,633742,190022,629007,89409,506056,970746,296958,457980,712725,964563,191730,1030667,480532,314191,195465,497219,757094,820281,50523,681828,677752,364158,448480,275616,818700,862879,1037997,601680,88681,154976,917648,40141,7622,432446,127445,476766,854713,643365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]