SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019374 LIMIT 1 [ RunTime:0.003791s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019374 [ RunTime:0.004356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916640,907687,552510,527592,535200,721857,23053,353397,220177,281023,959297,170083,530476,794460,633541,924467,759362,1026027,815744,458907,730927,139952,87055,933879,495178,238172,386564,874006,682353,1018552,1014646,238027,386563,167774,267718,750846,680751,1011856,91720,128950,293284,23451,140898,516024,372163,669294,523629,103136,299234,532711,268535,213235,1017491,605419,531917,92519,101799,608933,545056,79414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019374 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019374 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]